Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 726 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 68.2 KiB |
| Average record size in memory | 96.2 B |
Variable types
| NUM | 9 |
|---|---|
| CAT | 2 |
| DATE | 1 |
Reproduction
| Analysis started | 2020-04-10 07:48:14.384816 |
|---|---|
| Analysis finished | 2020-04-10 07:48:25.660684 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
20PDT001 is highly correlated with 20FT001 and 1 other fields | High Correlation |
20FT001 is highly correlated with 20PDT001 and 1 other fields | High Correlation |
50TT002 is highly correlated with 20FT001 and 3 other fields | High Correlation |
50FT001 is highly correlated with 50TT002 and 2 other fields | High Correlation |
50PDT001 is highly correlated with 50FT001 and 1 other fields | High Correlation |
50TV001 is highly correlated with 50FT001 and 2 other fields | High Correlation |
| Distinct count | 726 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 KiB |
| Minimum | 2020-01-01 12:00:00 |
|---|---|
| Maximum | 2020-06-30 18:00:00 |
Histogram
20TT001
Real number (ℝ≥0)
| Distinct count | 172 |
|---|---|
| Unique (%) | 23.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.97272727272727 |
|---|---|
| Minimum | 74.4 |
| Maximum | 97.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 74.4 |
|---|---|
| 5-th percentile | 79.6 |
| Q1 | 84.7 |
| median | 89.4 |
| Q3 | 91.7 |
| 95-th percentile | 95.2 |
| Maximum | 97.1 |
| Range | 22.7 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.832504883 |
|---|---|
| Coefficient of variation (CV) | 0.05493185256 |
| Kurtosis | -0.609557909 |
| Mean | 87.97272727 |
| Median Absolute Deviation (MAD) | 4.141172051 |
| Skewness | -0.3975460912 |
| Sum | 63868.2 |
| Variance | 23.35310345 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[74.4 79.05 80.75 82.45 84.55 ... 89.75 90.55 93.25 96.25 97.1 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 90 | 17 | 2.3% | |
| 89.9 | 17 | 2.3% | |
| 90.3 | 14 | 1.9% | |
| 84.9 | 14 | 1.9% | |
| 90.5 | 12 | 1.7% | |
| 85.2 | 11 | 1.5% | |
| 90.2 | 11 | 1.5% | |
| 85 | 11 | 1.5% | |
| 84.7 | 10 | 1.4% | |
| 84.8 | 10 | 1.4% | |
| Other values (162) | 599 | 82.5% |
| Value | Count | Frequency (%) | |
| 74.4 | 2 | 0.3% | |
| 74.6 | 2 | 0.3% | |
| 75.1 | 1 | 0.1% | |
| 75.3 | 1 | 0.1% | |
| 75.4 | 2 | 0.3% |
| Value | Count | Frequency (%) | |
| 97.1 | 1 | 0.1% | |
| 96.6 | 1 | 0.1% | |
| 96.5 | 1 | 0.1% | |
| 96.3 | 1 | 0.1% | |
| 96.2 | 3 | 0.4% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 KiB |
| 40 |
|---|
| Value | Count | Frequency (%) | |
| 40 | 726 | 100.0% |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
| Distinct count | 726 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54906.15308539945 |
|---|---|
| Minimum | 29005.2 |
| Maximum | 71003.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 29005.2 |
|---|---|
| 5-th percentile | 38635.7075 |
| Q1 | 46989.555 |
| median | 58916.75 |
| Q3 | 61780.3975 |
| 95-th percentile | 65672.4475 |
| Maximum | 71003.6 |
| Range | 41998.4 |
| Interquartile range (IQR) | 14790.8425 |
Descriptive statistics
| Standard deviation | 9399.66533 |
|---|---|
| Coefficient of variation (CV) | 0.1711951175 |
| Kurtosis | -0.551575726 |
| Mean | 54906.15309 |
| Median Absolute Deviation (MAD) | 8086.173096 |
| Skewness | -0.6824490775 |
| Sum | 39861867.14 |
| Variance | 88353708.31 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[29005.2 30747.345 37797.615 40770.16 43511.46 ... 58625.245 64211.635 65983.5 69786.9 71003.6 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 60354.57 | 1 | 0.1% | |
| 56816.95 | 1 | 0.1% | |
| 60718.21 | 1 | 0.1% | |
| 58613.52 | 1 | 0.1% | |
| 60224.93 | 1 | 0.1% | |
| 46007.55 | 1 | 0.1% | |
| 62130.22 | 1 | 0.1% | |
| 70259.06 | 1 | 0.1% | |
| 60033.12 | 1 | 0.1% | |
| 46454.02 | 1 | 0.1% | |
| Other values (716) | 716 | 98.6% |
| Value | Count | Frequency (%) | |
| 29005.2 | 1 | 0.1% | |
| 29342.98 | 1 | 0.1% | |
| 29381.37 | 1 | 0.1% | |
| 29516.16 | 1 | 0.1% | |
| 30244.88 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 71003.6 | 1 | 0.1% | |
| 70795.97 | 1 | 0.1% | |
| 70754.34 | 1 | 0.1% | |
| 70545.58 | 1 | 0.1% | |
| 70532.54 | 1 | 0.1% |
20TT002
Real number (ℝ≥0)
| Distinct count | 8 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.007438016528926 |
|---|---|
| Minimum | 23.9 |
| Maximum | 27.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 23.9 |
|---|---|
| 5-th percentile | 24.9 |
| Q1 | 25 |
| median | 25 |
| Q3 | 25.1 |
| 95-th percentile | 25.1 |
| Maximum | 27.6 |
| Range | 3.7 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.1314105686 |
|---|---|
| Coefficient of variation (CV) | 0.005254859314 |
| Kurtosis | 215.6755645 |
| Mean | 25.00743802 |
| Median Absolute Deviation (MAD) | 0.06203811215 |
| Skewness | 9.988584451 |
| Sum | 18155.4 |
| Variance | 0.01726873753 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[23.9 24.4 24.95 25.05 25.2 27.6 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 25 | 351 | 48.3% | |
| 25.1 | 193 | 26.6% | |
| 24.9 | 175 | 24.1% | |
| 25.4 | 2 | 0.3% | |
| 25.5 | 2 | 0.3% | |
| 27.6 | 1 | 0.1% | |
| 25.3 | 1 | 0.1% | |
| 23.9 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 23.9 | 1 | 0.1% | |
| 24.9 | 175 | 24.1% | |
| 25 | 351 | 48.3% | |
| 25.1 | 193 | 26.6% | |
| 25.3 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 27.6 | 1 | 0.1% | |
| 25.5 | 2 | 0.3% | |
| 25.4 | 2 | 0.3% | |
| 25.3 | 1 | 0.1% | |
| 25.1 | 193 | 26.6% |
| Distinct count | 259 |
|---|---|
| Unique (%) | 35.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.32289807162534434 |
|---|---|
| Minimum | 0.1 |
| Maximum | 0.499 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.169 |
| Q1 | 0.24625 |
| median | 0.3545 |
| Q3 | 0.39 |
| 95-th percentile | 0.43075 |
| Maximum | 0.499 |
| Range | 0.399 |
| Interquartile range (IQR) | 0.14375 |
Descriptive statistics
| Standard deviation | 0.09079862111 |
|---|---|
| Coefficient of variation (CV) | 0.2811990194 |
| Kurtosis | -0.768624015 |
| Mean | 0.3228980716 |
| Median Absolute Deviation (MAD) | 0.07788967056 |
| Skewness | -0.4719858403 |
| Sum | 234.424 |
| Variance | 0.008244389596 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.1 0.111 0.1625 0.1955 0.2125 ... 0.3165 0.3605 0.3945 0.4255 0.499 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.378 | 9 | 1.2% | |
| 0.372 | 9 | 1.2% | |
| 0.375 | 8 | 1.1% | |
| 0.381 | 8 | 1.1% | |
| 0.39 | 8 | 1.1% | |
| 0.367 | 8 | 1.1% | |
| 0.373 | 7 | 1.0% | |
| 0.412 | 7 | 1.0% | |
| 0.387 | 7 | 1.0% | |
| 0.424 | 7 | 1.0% | |
| Other values (249) | 648 | 89.3% |
| Value | Count | Frequency (%) | |
| 0.1 | 1 | 0.1% | |
| 0.101 | 1 | 0.1% | |
| 0.102 | 1 | 0.1% | |
| 0.103 | 1 | 0.1% | |
| 0.108 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.499 | 1 | 0.1% | |
| 0.495 | 1 | 0.1% | |
| 0.494 | 1 | 0.1% | |
| 0.491 | 2 | 0.3% | |
| 0.49 | 1 | 0.1% |
50TT001
Real number (ℝ≥0)
| Distinct count | 23 |
|---|---|
| Unique (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.54297520661157 |
|---|---|
| Minimum | 9.5 |
| Maximum | 11.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 9.5 |
|---|---|
| 5-th percentile | 9.6 |
| Q1 | 9.9 |
| median | 10.4 |
| Q3 | 11.3 |
| 95-th percentile | 11.7 |
| Maximum | 11.7 |
| Range | 2.2 |
| Interquartile range (IQR) | 1.4 |
Descriptive statistics
| Standard deviation | 0.7494358095 |
|---|---|
| Coefficient of variation (CV) | 0.07108390134 |
| Kurtosis | -1.360295495 |
| Mean | 10.54297521 |
| Median Absolute Deviation (MAD) | 0.6690799809 |
| Skewness | 0.3053668423 |
| Sum | 7654.2 |
| Variance | 0.5616540325 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 9.5 9.55 9.95 10.05 10.15 11.65 11.7 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 11.7 | 104 | 14.3% | |
| 10 | 79 | 10.9% | |
| 9.8 | 40 | 5.5% | |
| 9.7 | 40 | 5.5% | |
| 9.9 | 40 | 5.5% | |
| 10.1 | 40 | 5.5% | |
| 9.6 | 40 | 5.5% | |
| 9.5 | 36 | 5.0% | |
| 10.2 | 27 | 3.7% | |
| 10.5 | 20 | 2.8% | |
| Other values (13) | 260 | 35.8% |
| Value | Count | Frequency (%) | |
| 9.5 | 36 | 5.0% | |
| 9.6 | 40 | 5.5% | |
| 9.7 | 40 | 5.5% | |
| 9.8 | 40 | 5.5% | |
| 9.9 | 40 | 5.5% |
| Value | Count | Frequency (%) | |
| 11.7 | 104 | 14.3% | |
| 11.6 | 20 | 2.8% | |
| 11.5 | 20 | 2.8% | |
| 11.4 | 20 | 2.8% | |
| 11.3 | 20 | 2.8% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 KiB |
| 5 |
|---|
| Value | Count | Frequency (%) | |
| 5 | 726 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 1 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 1 | 100.0% |
| Distinct count | 604 |
|---|---|
| Unique (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 277033.1855647383 |
|---|---|
| Minimum | 70705.19 |
| Maximum | 600000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 70705.19 |
|---|---|
| 5-th percentile | 100674.2125 |
| Q1 | 184674.5125 |
| median | 261029.755 |
| Q3 | 345044.515 |
| 95-th percentile | 523904.2375 |
| Maximum | 600000 |
| Range | 529294.81 |
| Interquartile range (IQR) | 160370.0025 |
Descriptive statistics
| Standard deviation | 122273.2714 |
|---|---|
| Coefficient of variation (CV) | 0.4413668751 |
| Kurtosis | -0.2220162359 |
| Mean | 277033.1856 |
| Median Absolute Deviation (MAD) | 97388.98827 |
| Skewness | 0.5965705302 |
| Sum | 201126092.7 |
| Variance | 1.49507529e+10 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 70705.19 203558.175 359988.95 562657. 600000. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 340285.29 | 5 | 0.7% | |
| 145099.15 | 5 | 0.7% | |
| 366171.29 | 4 | 0.6% | |
| 214600.62 | 4 | 0.6% | |
| 246694.71 | 4 | 0.6% | |
| 216564.67 | 4 | 0.6% | |
| 600000 | 4 | 0.6% | |
| 506534.57 | 3 | 0.4% | |
| 559279.88 | 3 | 0.4% | |
| 246808.29 | 3 | 0.4% | |
| Other values (594) | 687 | 94.6% |
| Value | Count | Frequency (%) | |
| 70705.19 | 1 | 0.1% | |
| 75175.46 | 2 | 0.3% | |
| 77038.36 | 1 | 0.1% | |
| 77460.76 | 1 | 0.1% | |
| 78117.8 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 600000 | 4 | 0.6% | |
| 580239.84 | 2 | 0.3% | |
| 575859.43 | 1 | 0.1% | |
| 574206.43 | 1 | 0.1% | |
| 566034.12 | 1 | 0.1% |
| Distinct count | 100 |
|---|---|
| Unique (%) | 13.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.16418732782369 |
|---|---|
| Minimum | 16.1 |
| Maximum | 27.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 16.1 |
|---|---|
| 5-th percentile | 16.9 |
| Q1 | 18.3 |
| median | 19.7 |
| Q3 | 21.575 |
| 95-th percentile | 24.9 |
| Maximum | 27.1 |
| Range | 11 |
| Interquartile range (IQR) | 3.275 |
Descriptive statistics
| Standard deviation | 2.451872998 |
|---|---|
| Coefficient of variation (CV) | 0.1215954285 |
| Kurtosis | -0.2006415271 |
| Mean | 20.16418733 |
| Median Absolute Deviation (MAD) | 1.959665779 |
| Skewness | 0.6787935567 |
| Sum | 14639.2 |
| Variance | 6.011681201 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[16.1 16.75 18.05 20.75 23.25 24.25 25.15 27.1 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 19.3 | 24 | 3.3% | |
| 18.3 | 22 | 3.0% | |
| 20.5 | 20 | 2.8% | |
| 19.4 | 19 | 2.6% | |
| 19.1 | 18 | 2.5% | |
| 19.6 | 17 | 2.3% | |
| 20.6 | 17 | 2.3% | |
| 19.8 | 16 | 2.2% | |
| 20 | 16 | 2.2% | |
| 18.5 | 14 | 1.9% | |
| Other values (90) | 543 | 74.8% |
| Value | Count | Frequency (%) | |
| 16.1 | 1 | 0.1% | |
| 16.2 | 5 | 0.7% | |
| 16.3 | 3 | 0.4% | |
| 16.4 | 2 | 0.3% | |
| 16.5 | 5 | 0.7% |
| Value | Count | Frequency (%) | |
| 27.1 | 2 | 0.3% | |
| 27 | 1 | 0.1% | |
| 26.9 | 1 | 0.1% | |
| 26.8 | 2 | 0.3% | |
| 26.6 | 4 | 0.6% |
| Distinct count | 371 |
|---|---|
| Unique (%) | 51.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3113801652892562 |
|---|---|
| Minimum | 0.036000000000000004 |
| Maximum | 1.11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 0.036 |
|---|---|
| 5-th percentile | 0.06 |
| Q1 | 0.13 |
| median | 0.245 |
| Q3 | 0.398 |
| 95-th percentile | 0.8615 |
| Maximum | 1.11 |
| Range | 1.074 |
| Interquartile range (IQR) | 0.268 |
Descriptive statistics
| Standard deviation | 0.2387666906 |
|---|---|
| Coefficient of variation (CV) | 0.7668012198 |
| Kurtosis | 1.183853761 |
| Mean | 0.3113801653 |
| Median Absolute Deviation (MAD) | 0.1808103499 |
| Skewness | 1.338218457 |
| Sum | 226.062 |
| Variance | 0.05700953252 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.036 0.114 0.1255 0.2905 0.3025 0.446 0.9845 1.1085 1.11 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.181 | 8 | 1.1% | |
| 0.115 | 8 | 1.1% | |
| 0.07 | 8 | 1.1% | |
| 0.123 | 8 | 1.1% | |
| 0.174 | 7 | 1.0% | |
| 0.298 | 7 | 1.0% | |
| 0.221 | 7 | 1.0% | |
| 0.065 | 6 | 0.8% | |
| 0.301 | 6 | 0.8% | |
| 0.2 | 6 | 0.8% | |
| Other values (361) | 655 | 90.2% |
| Value | Count | Frequency (%) | |
| 0.036 | 2 | 0.3% | |
| 0.038 | 2 | 0.3% | |
| 0.039 | 3 | 0.4% | |
| 0.041 | 1 | 0.1% | |
| 0.042 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1.11 | 2 | 0.3% | |
| 1.109 | 1 | 0.1% | |
| 1.108 | 1 | 0.1% | |
| 1.043 | 2 | 0.3% | |
| 1.027 | 1 | 0.1% |
| Distinct count | 84 |
|---|---|
| Unique (%) | 11.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.46176308539944905 |
|---|---|
| Minimum | 0.12 |
| Maximum | 1.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.8 KiB |
Quantile statistics
| Minimum | 0.12 |
|---|---|
| 5-th percentile | 0.17 |
| Q1 | 0.31 |
| median | 0.435 |
| Q3 | 0.5775 |
| 95-th percentile | 0.87 |
| Maximum | 1 |
| Range | 0.88 |
| Interquartile range (IQR) | 0.2675 |
Descriptive statistics
| Standard deviation | 0.2036018537 |
|---|---|
| Coefficient of variation (CV) | 0.4409227592 |
| Kurtosis | -0.2222411765 |
| Mean | 0.4617630854 |
| Median Absolute Deviation (MAD) | 0.1622069683 |
| Skewness | 0.5986988252 |
| Sum | 335.24 |
| Variance | 0.04145371483 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.12 0.335 0.595 0.935 1. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.36 | 24 | 3.3% | |
| 0.48 | 24 | 3.3% | |
| 0.37 | 20 | 2.8% | |
| 0.47 | 20 | 2.8% | |
| 0.58 | 19 | 2.6% | |
| 0.49 | 17 | 2.3% | |
| 0.41 | 17 | 2.3% | |
| 0.39 | 17 | 2.3% | |
| 0.57 | 17 | 2.3% | |
| 0.4 | 17 | 2.3% | |
| Other values (74) | 534 | 73.6% |
| Value | Count | Frequency (%) | |
| 0.12 | 1 | 0.1% | |
| 0.13 | 7 | 1.0% | |
| 0.14 | 8 | 1.1% | |
| 0.15 | 6 | 0.8% | |
| 0.16 | 12 | 1.7% |
| Value | Count | Frequency (%) | |
| 1 | 4 | 0.6% | |
| 0.97 | 2 | 0.3% | |
| 0.96 | 2 | 0.3% | |
| 0.94 | 1 | 0.1% | |
| 0.93 | 7 | 1.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| Date | 20TT001 | 20PT001 | 20FT001 | 20TT002 | 20PDT001 | 50TT001 | 50PT001 | 50FT001 | 50TT002 | 50PDT001 | 50TV001 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-01-01 12:00:00 | 89.9 | 40 | 60898.59 | 25.0 | 0.378 | 10.0 | 5 | 291262.84 | 19.3 | 0.291 | 0.49 |
| 1 | 2020-01-01 18:00:00 | 90.6 | 40 | 60422.47 | 25.0 | 0.374 | 10.0 | 5 | 301308.55 | 19.1 | 0.309 | 0.50 |
| 2 | 2020-01-02 00:00:00 | 90.0 | 40 | 60996.54 | 25.1 | 0.380 | 10.0 | 5 | 297020.06 | 19.2 | 0.301 | 0.50 |
| 3 | 2020-01-02 06:00:00 | 90.2 | 40 | 59710.11 | 25.1 | 0.365 | 10.0 | 5 | 280091.64 | 19.6 | 0.278 | 0.47 |
| 4 | 2020-01-02 12:00:00 | 89.3 | 40 | 59863.03 | 25.1 | 0.366 | 10.0 | 5 | 280091.64 | 19.5 | 0.279 | 0.47 |
| 5 | 2020-01-02 18:00:00 | 90.0 | 40 | 61460.47 | 25.1 | 0.385 | 10.1 | 5 | 307031.88 | 19.0 | 0.320 | 0.51 |
| 6 | 2020-01-03 00:00:00 | 89.1 | 40 | 60643.57 | 24.9 | 0.375 | 10.1 | 5 | 292820.63 | 19.2 | 0.293 | 0.49 |
| 7 | 2020-01-03 06:00:00 | 87.8 | 40 | 60192.41 | 24.9 | 0.369 | 10.1 | 5 | 278609.38 | 19.3 | 0.276 | 0.46 |
| 8 | 2020-01-03 12:00:00 | 86.1 | 40 | 59473.81 | 25.0 | 0.361 | 10.1 | 5 | 257857.76 | 19.6 | 0.239 | 0.43 |
| 9 | 2020-01-03 18:00:00 | 86.0 | 40 | 59414.94 | 25.0 | 0.359 | 10.1 | 5 | 257857.76 | 19.6 | 0.239 | 0.43 |
Last rows
| Date | 20TT001 | 20PT001 | 20FT001 | 20TT002 | 20PDT001 | 50TT001 | 50PT001 | 50FT001 | 50TT002 | 50PDT001 | 50TV001 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 716 | 2020-06-28 12:00:00 | 84.7 | 40 | 71003.60 | 25.1 | 0.499 | 11.7 | 5 | 518776.81 | 17.2 | 0.846 | 0.86 |
| 717 | 2020-06-28 18:00:00 | 85.7 | 40 | 67284.09 | 25.0 | 0.452 | 11.7 | 5 | 459038.83 | 17.7 | 0.674 | 0.77 |
| 718 | 2020-06-29 00:00:00 | 84.9 | 40 | 65419.54 | 25.0 | 0.429 | 11.7 | 5 | 396038.83 | 18.4 | 0.512 | 0.66 |
| 719 | 2020-06-29 06:00:00 | 87.7 | 40 | 65542.99 | 25.1 | 0.431 | 11.7 | 5 | 443541.57 | 18.0 | 0.632 | 0.74 |
| 720 | 2020-06-29 12:00:00 | 88.4 | 40 | 66781.63 | 25.0 | 0.447 | 11.7 | 5 | 489775.74 | 17.6 | 0.759 | 0.82 |
| 721 | 2020-06-29 18:00:00 | 87.3 | 40 | 65889.61 | 24.9 | 0.436 | 11.7 | 5 | 458275.74 | 17.8 | 0.671 | 0.76 |
| 722 | 2020-06-30 00:00:00 | 87.6 | 40 | 66661.38 | 25.1 | 0.445 | 11.7 | 5 | 475030.73 | 17.7 | 0.718 | 0.79 |
| 723 | 2020-06-30 06:00:00 | 88.8 | 40 | 64044.87 | 25.0 | 0.414 | 11.7 | 5 | 439514.21 | 18.1 | 0.621 | 0.73 |
| 724 | 2020-06-30 12:00:00 | 79.3 | 40 | 64200.21 | 25.0 | 0.412 | 11.7 | 5 | 317542.32 | 18.9 | 0.341 | 0.53 |
| 725 | 2020-06-30 18:00:00 | 79.1 | 40 | 62763.88 | 25.1 | 0.394 | 11.7 | 5 | 289528.98 | 19.4 | 0.296 | 0.48 |